var UserSQL = {  
	insert:'INSERT INTO user(username,password,date,type,openid,head_url) VALUES(?,?,NOW(),?,?,?)', 
	bangding:'UPDATE user SET type = ?,openid = ? WHERE username = ? AND password = ? ',
	updateHeadImage: 'UPDATE user SET head_url = ? WHERE username = ? AND password = ? ',
	queryAll:'SELECT * FROM user',  
	getUserByOpenid:'SELECT * FROM user WHERE openid = ? ', 
	getUserByInfo:'SELECT * FROM user WHERE username = ? AND password = ? ',
	deleteUserByInfo:'DELETE FROM user WHERE username = ? AND password = ? ',
	testinert: 'insert into userTb (name,uid,date_time) values (?,?,NOW());',
	update1: 'UPDATE yymx_account SET balance = ? where account = ? ',
	update2: 'UPDATE yymx_account SET valid_balance = ?,recharge_balance = ? where account = ? '
};
 module.exports = UserSQL;